use subsidy_count, replace

*Table 1
collapse (sum) abatement rentalsubsidy statetaxcredit lowrateloanother_t30_* lowrateloanother_mean_* RL_* DL_* donations_othercontributions_* deferred_equity_* notloanother_* marketrateloanother_t30_* marketrateloanother_mean_*

use subsidy_count, replace

*Table 2
replace total_subsidies_t30 =8 if total_subsidies_t30 >8
replace total_subsidies_mean =8 if total_subsidies_mean >8

tab total_subsidies_t30
tab total_subsidies_mean

univar total_subsidies_t30
univar total_subsidies_mean

